Excel 2007 - Lookup Functions, Mathematical Functions, Financial Functions and Data Tables
      The "Excel 2007 - Lookup Functions, Mathematical Functions, Financial Functions and Data Tables" lesson covers the following topics:
  • Lookup Functions
  • Time and Mathematical Functions
  • Financial Functions and Data Tables
     
      Lookup Functions      
      Upon successful completion you will be able to:

1. Use the VLOOKUP Function;
2. Create Lookup Tables;
3. Use the Insert Function Box;
4. Adding VLOOKUP Values;
5. Manually Adding Formulas;
6. Modify Lookup Data;
7. Understand the HLOOKUP Function.
      
      Time and Mathematical Functions      
      Upon successful completion you will be able to:

1. Use the TODAY Function;
2. Use the DAY, MONTH and YEAR Functions;
3. Use the COUNT Function;
4. Use the COUNTA Function;
5. Use the COUNTIF Function;
6. Use the SUMIF Function;
7. Use the ROUND Function;
8. Nest Functions.
      
      Financial Functions and Data Tables      
      Upon successful completion you will be able to:

1. Understand Financial Arguments;
2. Use the FV Function;
3. Use the PMT Function;
4. Use the NPV Function;
5. Use the PV Function;
6. Use the RATE Function;
7. Use Data Tables.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2007 - Lookup Functions, Mathematical Functions, Financial Functions and Data Tables :
Program Training Courses - Microsoft Excel 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters